﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Drive.DbAccess
{
    public interface IDbInterface
    {
        string Name { get; }
        void TestConnection();
        IEnumerable<string> GetDatabases();
        IEnumerable<string> GetTables();
        IEnumerable<DataColumn> GetColumns(string table);
        int Update(DataTable datatable,string tableName, List<ColumnMapping> columnMappings, string updateByColumn);
        DataTable ExecuteDataTable(string sql);
    }
}
